SELECT * FROM london_stages WHERE eventid IN (1136, 1326, 24529, 33840, 33885, 33906, 34068, 34098, 34138, 34176, 34188, 34210, 34215, 34233, 34250, 34255, 34259, 34262, 34358, 34519, 34584, 34620, 34733, 34737, 34776, 34792, 35025, 35041, 35103, 35241, 35270, 35284, 35290, 35306, 35320, 35355, 35499, 35552, 35563, 35567, 35571, 35580, 35584, 35593, 35608, 35622, 35660, 35673, 35675, 35682, 35684, 35687, 35689, 35692, 35694, 35697, 35700, 35703, 35705, 35762, 35866, 35902, 35928, 35935, 35950, 35955, 35990, 36119, 36128, 36132, 36136, 36142, 36198, 36207, 36226, 36247, 36256, 36290, 36318, 36368, 36371, 36377, 36559, 36956, 36958, 36964, 36981, 36997, 37006, 37015, 37032, 37045, 37047, 37061, 37079, 37102, 37120, 37222, 37267, 37269, 37271, 37273, 37275, 37277, 37336, 37383, 37452, 37551, 37612, 37657, 37660, 37802, 37820, 37896, 37898, 37906, 37910, 37920, 37924, 37936, 38033, 38134, 38157, 38515, 38722, 38732, 38945, 38947, 38952, 38959, 38963, 38966, 38968, 39009, 39012, 39025, 39029, 39031, 39046, 39055, 39115, 39316, 39430, 39790, 39855, 40367, 40398, 40411, 40413, 40425, 40431, 40433, 40448, 40570, 40572, 40589, 40591, 40593, 40596, 40600, 40602, 40604, 40606, 40608, 40611, 40613, 40615, 40617, 40619, 40624, 40630, 40634, 40653, 40658, 40660, 40663, 40665, 40667, 40669, 40672, 40674, 40677, 40679, 40681, 40683, 40686, 40688, 40691, 40693, 40695, 40700, 40703, 40706, 40708, 40711, 40714, 40717, 40719, 40721, 40723, 40726, 40729, 40732, 40734, 40741, 40743, 40746, 40755, 40761, 40765, 40767, 40770, 40775, 40777, 40781, 40787, 40789, 40795, 40797, 40801, 40804, 40807, 40809, 40816, 40821, 40825, 40828, 40831, 40833, 40839, 40842, 40845, 40848, 40852, 40856, 40859, 40866, 40870, 40873, 40876, 40882, 40884, 40886, 40889, 40891, 40898, 40902, 40910, 40912, 40915, 40917, 40922, 40928, 40938, 40941, 40943, 40946, 40951, 40953, 40956, 40958, 40960, 40962, 40965, 40967, 40970, 40972, 40974, 40978, 40980, 40983, 40985, 40987, 40989, 40992, 40997, 41002, 41005, 41115, 41117, 41119, 41122, 41125, 41127, 41130, 41137, 41139, 41141, 41145, 41150, 41152, 41154, 41156, 41158, 41160, 41162, 41166, 41171, 41176, 41184, 41187, 41194, 41196, 41205, 41211, 41224, 41231, 41233, 41241, 41247, 41250, 41259, 41261, 41264, 41269, 41273, 41275, 41278, 41283, 41295, 41301, 41318, 41323, 41327, 41338, 41342, 41344, 41361, 41394, 41408, 41417, 41425, 41430, 41461, 41474, 41476, 41485, 41503, 41513, 41515, 41529, 41532, 41537, 41542, 41544, 41547, 41552, 41557, 41562, 41564, 41569, 41571, 41691, 41693, 41695, 41697, 41699, 41701, 41707, 41709, 41716, 41727, 41729, 41731, 41733, 41737, 41739, 41741, 41745, 41749, 41751, 41753, 41757, 41761, 41763, 41765, 41768, 41770, 41774, 41776, 41779, 41781, 41784, 41786, 41788, 41790, 41793, 41795, 41800, 41802, 41804, 41807, 41814, 41816, 41823, 41828, 41833, 41836, 41841, 41846, 41851, 41853, 41856, 41858, 41861, 41863, 41866, 41868, 41870, 41872, 41875, 41877, 41880, 41882, 41885, 41887, 41890, 41893, 41896, 41898, 41901, 41903, 41906, 41909, 41912, 41914, 41916, 41918, 41921, 41923, 41926, 41929, 41931, 41934, 41936, 41939, 41941, 41945, 41976, 41980, 41984, 41987, 41994, 41998, 42001, 42003, 42011, 42017, 42021, 42026, 42040, 42042, 42045, 42047, 42056, 42058, 42061, 42063, 42066, 42073, 42081, 42086, 42091, 42098, 42101, 42111, 42122, 42124, 42127, 42129, 42132, 42134, 42137, 42142, 42144, 42147, 42152, 42154, 42157, 42163, 42270, 42271, 42272, 42293, 42294, 42299, 42302, 42306, 42310, 42312, 42314, 42318, 42324, 42328, 42330, 42338, 42354, 42357, 42372, 42392, 42398, 42420, 42422, 42430, 42432, 42461, 42467, 42486, 42496, 42549, 42559, 42561, 42566, 42569, 42625, 42633, 42649, 42659, 42670, 42672, 42677, 42678, 42692, 42697, 42699, 42721, 42726, 42728, 42731, 42741, 42747, 42787, 42788, 42791, 42795, 42798, 42799, 42800, 42805, 42807, 42817, 42818, 42829, 42841, 42843, 42868, 42874, 42879, 42882, 42884, 42886, 42894, 42899, 42911, 42912, 42914, 42916, 42918, 42922, 42924, 42930, 42934, 42938, 42940, 42946, 42954, 42958, 42965, 42999, 43008, 43010, 43012, 43015, 43017, 43024, 43029, 43031, 43038, 43043, 43067, 43077, 43079, 43081, 43084, 43093, 43098, 43101, 43104, 43115, 43127, 43143, 43186, 43191, 43195, 43200, 43219, 43222, 43229, 43232, 43237, 43247, 43249, 43255, 43260, 43263, 43265, 43285, 43293, 43303, 43310, 43313, 43318, 43321, 43325, 43336, 43342, 43347, 43395, 43400, 43407, 43432, 43439, 43444, 43446, 43448, 43449, 43451, 43453, 43455, 43460, 43463, 43470, 43472, 43484, 43494, 43498, 43506, 43510, 43529, 43535, 43539, 43557, 43559, 43564, 43566, 43568, 43570, 43572, 43575, 43577, 43580, 43585, 43594, 43596, 43599, 43601, 43604, 43608, 43610, 43613, 43615, 43618, 43620, 43622, 43624, 43627, 43629, 43633, 43638, 43644, 43653, 43659, 43662, 43664, 43668, 43674, 43689, 43702, 43707, 43712, 43718, 43726, 43732, 43736, 43743, 43752, 43756, 43767, 43770, 43772, 43776, 43779, 43781, 43784, 43786, 43792, 43795, 43801, 43803, 43809, 43812, 43815, 43818, 43824, 43826, 43832, 43836, 43838, 43841, 43844, 43847, 43849, 43852, 43854, 43856, 43858, 43861, 43863, 43866, 43873, 43876, 43883, 43886, 43891, 43893, 43896, 43900, 43920, 43923, 43936, 43944, 43951, 43963, 43967, 43974, 43986, 43987, 44000, 44013, 44015, 44019, 44029, 44031, 44033, 44035, 44037, 44039, 44041, 44046, 44050, 44054, 44056, 44061, 44063, 44066, 44068, 44070, 44072, 44076, 44085, 44089, 44091, 44093, 44095, 44099, 44101, 44105, 44107, 44113, 44115, 44125, 44131, 44133, 44137, 44139, 44143, 44149, 44155, 44159, 44165, 44167, 44172, 44176, 44178, 44182, 44184, 44190, 44196, 44198, 44202, 44208, 44212, 44214, 44221, 44225, 44227, 44233, 44239, 44244, 44247, 44249, 44251, 44253, 44275, 44277, 44279, 44286, 44293, 44303, 44319, 44341, 44345, 44369, 44382, 44394, 44409, 44414, 44417, 44419, 44427, 44432, 44434, 44439, 44444, 44447, 44449, 44452, 44454, 44457, 44459, 44464, 44466, 44467, 44481, 44490, 44492, 44493, 44495, 44498, 44499, 44503, 44504, 44508, 44515, 44517, 44523, 44526, 44527, 44532, 44553, 44556, 44557, 44559, 44560, 44562, 44563, 44564, 44566, 44570, 44575, 44576, 44580, 44581, 44585, 44586, 44591, 44599, 44605, 44618, 44628, 44634, 44645, 44648, 44668, 44692, 44708, 44712, 44719, 44726, 44733, 44735, 44737, 44748, 44762, 44771, 44774, 44780, 44791, 44819, 44859, 44862, 44870, 44873, 44879, 44883, 44903, 44912, 44914, 44915, 44920, 44951, 44957, 44960, 44997, 45012, 45017, 45019, 45153, 45160, 45175, 45177, 45185, 45187, 45189, 45195, 45282, 45284, 45286, 45288, 45290, 45294, 45296, 45299, 45304, 45306, 45309, 45311, 45313, 45318, 45320, 45323, 45325, 45327, 45329, 45332, 45334, 45339, 45341, 45343, 45348, 45351, 45355, 45360, 45368, 45371, 45373, 45377, 45380, 45383, 45385, 45389, 45393, 45406, 45409, 45419, 45435, 45437, 45439, 45445, 45448, 45450, 45455, 45479, 45486, 45489, 45505, 45518, 45520, 45538, 45543, 45546, 45548, 45551, 45553, 45556, 45563, 45578, 45590, 45603, 50737) GROUP BY eventid ORDER BY eventdate ASC OPTION

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?

Performances

Mainpiece Title: Calisto; Or, The Chaste Nimph

Afterpiece Title: Calisto's Additional performers

Cast
Role: Bass Violls Actor: Coleman, Stephkins, Bates

Performances

Mainpiece Title: The Rambling Justice; Or, The Jealous Husbands; With The Humours Of Sir John Twiford

Cast
Role: Emilia Actor: Mrs Bates

Performances

Mainpiece Title: The Recruiting Officer

Cast
Role: Plume Actor: Bates

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: Lethe

Cast
Role: Charon Actor: Bates

Dance: IV: The Merry Sailors, as17671009; End: A New Pantomime Dance-Fishar, Sga Manesiere

Performances

Mainpiece Title: The Provok'd Husband; Or, A Journey To London

Cast
Role: Poundage Actor: Bates

Afterpiece Title: The Oxonian in Town

Dance: II: New Comic Dance, as17671106; End: The Merry Sailors, as17671009

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: The Upholsterer

Cast
Role: Watchman Actor: Bates.

Dance: End: A New Pantomime Dance, as17671016

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Beggar Actor: Bates.

Afterpiece Title: Orpheus and Eurydice

Performances

Mainpiece Title: Lionel And Clarissa

Afterpiece Title: The Old Maid

Cast
Role: Servant Actor: Bates

Dance: End of Opera: The Merry Sailors, as17671009

Performances

Mainpiece Title: Medea

Cast
Role: Children Actor: Mas. Harris, Mas. Bates

Afterpiece Title: The Musical Lady

Dance: End: The Highland Reel, as17680307

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: Amelia

Cast
Role: Peter Actor: Bates

Dance: III: The Provenzales, as17680301 IV: The Irish Lilt, as17670921

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: The Englishman in Paris

Cast
Role: Roger Actor: Bates.

Dance: III: The Merry Sailors, as17671009

Performances

Mainpiece Title: King Lear

Afterpiece Title: Amelia

Cast
Role: Peter Actor: Bates

Dance: End: The Highland Reel, as17680307

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Beggar Actor: Bates.

Afterpiece Title: Lethe

Cast
Role: Charon Actor: Bates

Dance: II: The Irish Lilt, as17670921

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: Amelia

Cast
Role: Peter Actor: Bates

Dance: III: The Provenzales, as17680301

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Beggar Actor: Bates.

Afterpiece Title: The Upholsterer

Ballet: End of Opera: The Wapping Landlady. As17680416

Performances

Mainpiece Title: The Inconstant

Cast
Role: Bravos Actor: Wignel, Quick, Stoppelaer, Bates

Afterpiece Title: The Royal Chace

Song: II: A Song-Parsons

Dance: III: A Minuet-Hussey, Miss Madden; IV: Comic Dance-Arnauld, Miss Capon, as17680416

Performances

Mainpiece Title: The Provok'd Husband

Cast
Role: Poundage Actor: Bates

Afterpiece Title: Orpheus and Eurydice

Dance: II: The Highland Reel, as17680307

Performances

Mainpiece Title: King Richard Iii

Cast
Role: Tyrrel Actor: Bates

Afterpiece Title: Duke and no Duke

Dance: II: By Particular Desire, a Minuet-Dumai, a Young Lady his scholar; End: The Highland Reel, as17680307

Performances

Mainpiece Title: The Provok'd Husband

Cast
Role: Poundage Actor: Bates

Afterpiece Title: Midas

Dance: III: The Irish Lilt-Aldridge, Sga Manesiere. [See17670921.

Performances

Mainpiece Title: The Inconstant

Cast
Role: Bravos Actor: Wignell, Quick, Stoplaer, Bates

Afterpiece Title: Thomasand Sally

Dance: III: The Provenzales, as17681123; IV: The Reel, as17681212

Performances

Mainpiece Title: The Inconstant

Cast
Role: Bravos Actor: Wignell, Quick, Stoplaer, Bates

Afterpiece Title: Apollo and Daphne

Dance: IV: The Irish Lilt, as17680930

Performances

Mainpiece Title: The Provok'd Husband

Cast
Role: Poundage Actor: Bates

Afterpiece Title: Harlequin Skeleton

Dance: IV: The Lamplighters, as17681101

Performances

Mainpiece Title: King Lear

Afterpiece Title: Lethe

Cast
Role: Charon Actor: Bates

Dance: End: The Wapping Landlady-, Double Hornpipe, as17690408

Performances

Mainpiece Title: The Provok'd Husband

Cast
Role: Poundage Actor: Bates

Afterpiece Title: Thomasand Sally

Dance: End: The Irish Lilt, as17680930

Performances

Mainpiece Title: King John

Cast
Role: Prince Arthur Actor: Mas. Bates

Afterpiece Title: Harlequin Dr Faustus

Dance: IV: The Wapping Landlady, Double Hornpipe, as17690408